# _*_ coding utf-8 _*_
# FILENAME：scheduleModel.py
# DESCRIPTION: 排班 Model
# AUTH: jarvis zhang
# DATE: 2022/6/2 10:00 下午

from sqlalchemy import Index, Column, String, Integer

## 排班
from models.baseModel import BaseModel


class ScheduleModel(BaseModel):
    # 表的名字:
    __tablename__ = 'schedule'
    # 表的结构:
    item = Column(String(32), comment='时间项')
    begin_time = Column(String(32), comment='开始时间')
    end_time = Column(String(32), comment='结束时间')
    order_type = Column(String(32), comment='排班类型 1.短白班 2.长白班 3.白夜班')
    work_type = Column(String(32), comment='作息类型 1.上班时间 2.休息时间')
    factory_id = Column(String(64), comment='工厂编号')
    # 添加索引和表注释
    __table_args__ = ({'comment': '排班'})

